using com.byt.suce.db.dao;
using System;
using System.Data;
using System.Data.Common;
using com.byt.webcore;
using System.Collections.Generic;
using MYLSOFT.JsonSimple;
using System.Data.SqlClient;

namespace com.byt.suce.db.mapper {

    public class PkgGestorq : AbstractDataAccessObject , IPkgGestorq {

        public PkgGestorq() {
        }

        public PkgGestorq.GetPendienteParam getPendiente(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.GetPendienteParam param = newGetPendienteParam(map);
            getPendiente(conn, param);
            return param;
        }

        public PkgGestorq.GetPendienteParam getPendiente(Connection conn, JSONObject json) {
            PkgGestorq.GetPendienteParam param = newGetPendienteParam(json);
            getPendiente(conn, param);
            return param;
        }

        public PkgGestorq.GetPendienteParam getPendiente(Connection conn) {
            PkgGestorq.GetPendienteParam param = newGetPendienteParam();
            getPendiente(conn, param);
            return param;
        }

        public void getPendiente(Connection conn, PkgGestorq.GetPendienteParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_get_pendiente";
            DbParameter par = null;
            // idqultimo
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idqultimo";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idqultimo == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idqultimo;
            // cur_out
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@cur_out";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.Object;
            par.Value = DBNull.Value;
            DataSet ds = new DataSet();
            DataAdapter da = new SqlDataAdapter((SqlCommand)cmd);
            da.Fill(ds);
            param.CurOut = (DbDataReader)ds.Tables[0].CreateDataReader();
        }

        public PkgGestorq.N11GetParam n11Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N11GetParam param = newN11GetParam(map);
            n11Get(conn, param);
            return param;
        }

        public PkgGestorq.N11GetParam n11Get(Connection conn, JSONObject json) {
            PkgGestorq.N11GetParam param = newN11GetParam(json);
            n11Get(conn, param);
            return param;
        }

        public PkgGestorq.N11GetParam n11Get(Connection conn) {
            PkgGestorq.N11GetParam param = newN11GetParam();
            n11Get(conn, param);
            return param;
        }

        public void n11Get(Connection conn, PkgGestorq.N11GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N11_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // numeorden
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numeorden";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 50;
            if (string.IsNullOrEmpty(param.Numeorden))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numeorden;
            // idsubsanacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idsubsanacion";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.Int32;
            if (param.Idsubsanacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idsubsanacion;
            // numesuce
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numesuce";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 50;
            if (string.IsNullOrEmpty(param.Numesuce))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numesuce;
            // texto
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@texto";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 1000;
            if (string.IsNullOrEmpty(param.Texto))
                par.Value = DBNull.Value;
            else
                par.Value = param.Texto;
            cmd.ExecuteNonQuery();
            if(DBNull.Value.Equals(cmd.Parameters["@numeorden"].Value))
                param.Numeorden = null;
            else
                param.Numeorden = (string)cmd.Parameters["@numeorden"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@idsubsanacion"].Value))
                param.Idsubsanacion = null;
            else
                param.Idsubsanacion = (int?)cmd.Parameters["@idsubsanacion"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@numesuce"].Value))
                param.Numesuce = null;
            else
                param.Numesuce = (string)cmd.Parameters["@numesuce"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@texto"].Value))
                param.Texto = null;
            else
                param.Texto = (string)cmd.Parameters["@texto"].Value;
        }

        public PkgGestorq.N11SetParam n11Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N11SetParam param = newN11SetParam(map);
            n11Set(conn, param);
            return param;
        }

        public PkgGestorq.N11SetParam n11Set(Connection conn, JSONObject json) {
            PkgGestorq.N11SetParam param = newN11SetParam(json);
            n11Set(conn, param);
            return param;
        }

        public PkgGestorq.N11SetParam n11Set(Connection conn) {
            PkgGestorq.N11SetParam param = newN11SetParam();
            n11Set(conn, param);
            return param;
        }

        public void n11Set(Connection conn, PkgGestorq.N11SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N11_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.N15GetParam n15Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N15GetParam param = newN15GetParam(map);
            n15Get(conn, param);
            return param;
        }

        public PkgGestorq.N15GetParam n15Get(Connection conn, JSONObject json) {
            PkgGestorq.N15GetParam param = newN15GetParam(json);
            n15Get(conn, param);
            return param;
        }

        public PkgGestorq.N15GetParam n15Get(Connection conn) {
            PkgGestorq.N15GetParam param = newN15GetParam();
            n15Get(conn, param);
            return param;
        }

        public void n15Get(Connection conn, PkgGestorq.N15GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N15_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // numeorden
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numeorden";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 50;
            if (string.IsNullOrEmpty(param.Numeorden))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numeorden;
            // numemto
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numemto";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 50;
            if (string.IsNullOrEmpty(param.Numemto))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numemto;
            // texto
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@texto";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 1000;
            if (string.IsNullOrEmpty(param.Texto))
                par.Value = DBNull.Value;
            else
                par.Value = param.Texto;
            cmd.ExecuteNonQuery();
            if(DBNull.Value.Equals(cmd.Parameters["@numeorden"].Value))
                param.Numeorden = null;
            else
                param.Numeorden = (string)cmd.Parameters["@numeorden"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@numemto"].Value))
                param.Numemto = null;
            else
                param.Numemto = (string)cmd.Parameters["@numemto"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@texto"].Value))
                param.Texto = null;
            else
                param.Texto = (string)cmd.Parameters["@texto"].Value;
        }

        public PkgGestorq.N15SetParam n15Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N15SetParam param = newN15SetParam(map);
            n15Set(conn, param);
            return param;
        }

        public PkgGestorq.N15SetParam n15Set(Connection conn, JSONObject json) {
            PkgGestorq.N15SetParam param = newN15SetParam(json);
            n15Set(conn, param);
            return param;
        }

        public PkgGestorq.N15SetParam n15Set(Connection conn) {
            PkgGestorq.N15SetParam param = newN15SetParam();
            n15Set(conn, param);
            return param;
        }

        public void n15Set(Connection conn, PkgGestorq.N15SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N15_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.N17GetParam n17Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N17GetParam param = newN17GetParam(map);
            n17Get(conn, param);
            return param;
        }

        public PkgGestorq.N17GetParam n17Get(Connection conn, JSONObject json) {
            PkgGestorq.N17GetParam param = newN17GetParam(json);
            n17Get(conn, param);
            return param;
        }

        public PkgGestorq.N17GetParam n17Get(Connection conn) {
            PkgGestorq.N17GetParam param = newN17GetParam();
            n17Get(conn, param);
            return param;
        }

        public void n17Get(Connection conn, PkgGestorq.N17GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N17_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // numeorden
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numeorden";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 50;
            if (string.IsNullOrEmpty(param.Numeorden))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numeorden;
            // idsubsanacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idsubsanacion";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.Int32;
            if (param.Idsubsanacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idsubsanacion;
            // numesuce
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numesuce";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 50;
            if (string.IsNullOrEmpty(param.Numesuce))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numesuce;
            // tasa
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@tasa";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.Decimal;
            if (param.Tasa == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Tasa;
            // plazo
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@plazo";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.Int32;
            if (param.Plazo == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Plazo;
            // texto
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@texto";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 4000;
            if (string.IsNullOrEmpty(param.Texto))
                par.Value = DBNull.Value;
            else
                par.Value = param.Texto;
            cmd.ExecuteNonQuery();
            if(DBNull.Value.Equals(cmd.Parameters["@numeorden"].Value))
                param.Numeorden = null;
            else
                param.Numeorden = (string)cmd.Parameters["@numeorden"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@idsubsanacion"].Value))
                param.Idsubsanacion = null;
            else
                param.Idsubsanacion = (int?)cmd.Parameters["@idsubsanacion"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@numesuce"].Value))
                param.Numesuce = null;
            else
                param.Numesuce = (string)cmd.Parameters["@numesuce"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@tasa"].Value))
                param.Tasa = null;
            else
                param.Tasa = (decimal?)cmd.Parameters["@tasa"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@plazo"].Value))
                param.Plazo = null;
            else
                param.Plazo = (int?)cmd.Parameters["@plazo"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@texto"].Value))
                param.Texto = null;
            else
                param.Texto = (string)cmd.Parameters["@texto"].Value;
        }

        public PkgGestorq.N17SetParam n17Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N17SetParam param = newN17SetParam(map);
            n17Set(conn, param);
            return param;
        }

        public PkgGestorq.N17SetParam n17Set(Connection conn, JSONObject json) {
            PkgGestorq.N17SetParam param = newN17SetParam(json);
            n17Set(conn, param);
            return param;
        }

        public PkgGestorq.N17SetParam n17Set(Connection conn) {
            PkgGestorq.N17SetParam param = newN17SetParam();
            n17Set(conn, param);
            return param;
        }

        public void n17Set(Connection conn, PkgGestorq.N17SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N17_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.N19GetParam n19Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N19GetParam param = newN19GetParam(map);
            n19Get(conn, param);
            return param;
        }

        public PkgGestorq.N19GetParam n19Get(Connection conn, JSONObject json) {
            PkgGestorq.N19GetParam param = newN19GetParam(json);
            n19Get(conn, param);
            return param;
        }

        public PkgGestorq.N19GetParam n19Get(Connection conn) {
            PkgGestorq.N19GetParam param = newN19GetParam();
            n19Get(conn, param);
            return param;
        }

        public void n19Get(Connection conn, PkgGestorq.N19GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N19_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // numemos
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numemos";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 20;
            if (string.IsNullOrEmpty(param.Numemos))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numemos;
            // numesuce
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numesuce";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 20;
            if (string.IsNullOrEmpty(param.Numesuce))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numesuce;
            // texto
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@texto";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 1000;
            if (string.IsNullOrEmpty(param.Texto))
                par.Value = DBNull.Value;
            else
                par.Value = param.Texto;
            // numero orden
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numeorden";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 20;
            if (string.IsNullOrEmpty(param.Numeorden))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numeorden;
            // version
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@version";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.Int32;
            if (param.Version == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Version;

            cmd.ExecuteNonQuery();

            if(DBNull.Value.Equals(cmd.Parameters["@numemos"].Value))
                param.Numemos = null;
            else
                param.Numemos = (string)cmd.Parameters["@numemos"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@numesuce"].Value))
                param.Numesuce = null;
            else
                param.Numesuce = (string)cmd.Parameters["@numesuce"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@texto"].Value))
                param.Texto = null;
            else
                param.Texto = (string)cmd.Parameters["@texto"].Value;

            if (DBNull.Value.Equals(cmd.Parameters["@numeorden"].Value))
                param.Numeorden = null;
            else
                param.Numeorden = (string)cmd.Parameters["@numeorden"].Value;
            if (DBNull.Value.Equals(cmd.Parameters["@version"].Value))
                param.Version = null;
            else
                param.Version = (int)cmd.Parameters["@version"].Value;

        }

        public PkgGestorq.N19SetParam n19Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N19SetParam param = newN19SetParam(map);
            n19Set(conn, param);
            return param;
        }

        public PkgGestorq.N19SetParam n19Set(Connection conn, JSONObject json) {
            PkgGestorq.N19SetParam param = newN19SetParam(json);
            n19Set(conn, param);
            return param;
        }

        public PkgGestorq.N19SetParam n19Set(Connection conn) {
            PkgGestorq.N19SetParam param = newN19SetParam();
            n19Set(conn, param);
            return param;
        }

        public void n19Set(Connection conn, PkgGestorq.N19SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N19_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.N2GetParam n2Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N2GetParam param = newN2GetParam(map);
            n2Get(conn, param);
            return param;
        }

        public PkgGestorq.N2GetParam n2Get(Connection conn, JSONObject json) {
            PkgGestorq.N2GetParam param = newN2GetParam(json);
            n2Get(conn, param);
            return param;
        }

        public PkgGestorq.N2GetParam n2Get(Connection conn) {
            PkgGestorq.N2GetParam param = newN2GetParam();
            n2Get(conn, param);
            return param;
        }

        public void n2Get(Connection conn, PkgGestorq.N2GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N2_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // docnumero
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@docnumero";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 20;
            if (string.IsNullOrEmpty(param.Docnumero))
                par.Value = DBNull.Value;
            else
                par.Value = param.Docnumero;
            // codformato
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@codformato";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 10;
            if (string.IsNullOrEmpty(param.Codformato))
                par.Value = DBNull.Value;
            else
                par.Value = param.Codformato;
            // tasa
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@tasa";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.Decimal;
            if (param.Tasa == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Tasa;
            cmd.ExecuteNonQuery();
            if(DBNull.Value.Equals(cmd.Parameters["@docnumero"].Value))
                param.Docnumero = null;
            else
                param.Docnumero = (string)cmd.Parameters["@docnumero"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@codformato"].Value))
                param.Codformato = null;
            else
                param.Codformato = (string)cmd.Parameters["@codformato"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@tasa"].Value))
                param.Tasa = null;
            else
                param.Tasa = (decimal?)cmd.Parameters["@tasa"].Value;
        }

        public PkgGestorq.N2SetParam n2Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N2SetParam param = newN2SetParam(map);
            n2Set(conn, param);
            return param;
        }

        public PkgGestorq.N2SetParam n2Set(Connection conn, JSONObject json) {
            PkgGestorq.N2SetParam param = newN2SetParam(json);
            n2Set(conn, param);
            return param;
        }

        public PkgGestorq.N2SetParam n2Set(Connection conn) {
            PkgGestorq.N2SetParam param = newN2SetParam();
            n2Set(conn, param);
            return param;
        }

        public void n2Set(Connection conn, PkgGestorq.N2SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N2_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.N21GetParam n21Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N21GetParam param = newN21GetParam(map);
            n21Get(conn, param);
            return param;
        }

        public PkgGestorq.N21GetParam n21Get(Connection conn, JSONObject json) {
            PkgGestorq.N21GetParam param = newN21GetParam(json);
            n21Get(conn, param);
            return param;
        }

        public PkgGestorq.N21GetParam n21Get(Connection conn) {
            PkgGestorq.N21GetParam param = newN21GetParam();
            n21Get(conn, param);
            return param;
        }

        public void n21Get(Connection conn, PkgGestorq.N21GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N21_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // numemos
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numemos";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 20;
            if (string.IsNullOrEmpty(param.Numemos))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numemos;
            // numesuce
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numesuce";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 10;
            if (string.IsNullOrEmpty(param.Numesuce))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numesuce;
            cmd.ExecuteNonQuery();
            if(DBNull.Value.Equals(cmd.Parameters["@numemos"].Value))
                param.Numemos = null;
            else
                param.Numemos = (string)cmd.Parameters["@numemos"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@numesuce"].Value))
                param.Numesuce = null;
            else
                param.Numesuce = (string)cmd.Parameters["@numesuce"].Value;
        }

        public PkgGestorq.N21SetParam n21Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N21SetParam param = newN21SetParam(map);
            n21Set(conn, param);
            return param;
        }

        public PkgGestorq.N21SetParam n21Set(Connection conn, JSONObject json) {
            PkgGestorq.N21SetParam param = newN21SetParam(json);
            n21Set(conn, param);
            return param;
        }

        public PkgGestorq.N21SetParam n21Set(Connection conn) {
            PkgGestorq.N21SetParam param = newN21SetParam();
            n21Set(conn, param);
            return param;
        }

        public void n21Set(Connection conn, PkgGestorq.N21SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N21_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.N22GetParam n22Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N22GetParam param = newN22GetParam(map);
            n22Get(conn, param);
            return param;
        }

        public PkgGestorq.N22GetParam n22Get(Connection conn, JSONObject json) {
            PkgGestorq.N22GetParam param = newN22GetParam(json);
            n22Get(conn, param);
            return param;
        }

        public PkgGestorq.N22GetParam n22Get(Connection conn) {
            PkgGestorq.N22GetParam param = newN22GetParam();
            n22Get(conn, param);
            return param;
        }

        public void n22Get(Connection conn, PkgGestorq.N22GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N22_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // nummos
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@nummos";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 20;
            if (string.IsNullOrEmpty(param.Nummos))
                par.Value = DBNull.Value;
            else
                par.Value = param.Nummos;
            // numsuce
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numsuce";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 20;
            if (string.IsNullOrEmpty(param.Numsuce))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numsuce;
            // tasa
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@tasa";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.Decimal;
            if (param.Tasa == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Tasa;
            cmd.ExecuteNonQuery();
            if(DBNull.Value.Equals(cmd.Parameters["@nummos"].Value))
                param.Nummos = null;
            else
                param.Nummos = (string)cmd.Parameters["@nummos"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@numsuce"].Value))
                param.Numsuce = null;
            else
                param.Numsuce = (string)cmd.Parameters["@numsuce"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@tasa"].Value))
                param.Tasa = null;
            else
                param.Tasa = (decimal?)cmd.Parameters["@tasa"].Value;
        }

        public PkgGestorq.N22SetParam n22Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N22SetParam param = newN22SetParam(map);
            n22Set(conn, param);
            return param;
        }

        public PkgGestorq.N22SetParam n22Set(Connection conn, JSONObject json) {
            PkgGestorq.N22SetParam param = newN22SetParam(json);
            n22Set(conn, param);
            return param;
        }

        public PkgGestorq.N22SetParam n22Set(Connection conn) {
            PkgGestorq.N22SetParam param = newN22SetParam();
            n22Set(conn, param);
            return param;
        }

        public void n22Set(Connection conn, PkgGestorq.N22SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N22_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.N36GetParam n36Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N36GetParam param = newN36GetParam(map);
            n36Get(conn, param);
            return param;
        }

        public PkgGestorq.N36GetParam n36Get(Connection conn, JSONObject json) {
            PkgGestorq.N36GetParam param = newN36GetParam(json);
            n36Get(conn, param);
            return param;
        }

        public PkgGestorq.N36GetParam n36Get(Connection conn) {
            PkgGestorq.N36GetParam param = newN36GetParam();
            n36Get(conn, param);
            return param;
        }

        public void n36Get(Connection conn, PkgGestorq.N36GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N36_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // cur_out
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@cur_out";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.Object;
            par.Value = DBNull.Value;
            DataSet ds = new DataSet();
            DataAdapter da = new SqlDataAdapter((SqlCommand)cmd);
            da.Fill(ds);
            param.CurOut = (DbDataReader)ds.Tables[0].CreateDataReader();
        }

        public PkgGestorq.N36SetParam n36Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N36SetParam param = newN36SetParam(map);
            n36Set(conn, param);
            return param;
        }

        public PkgGestorq.N36SetParam n36Set(Connection conn, JSONObject json) {
            PkgGestorq.N36SetParam param = newN36SetParam(json);
            n36Set(conn, param);
            return param;
        }

        public PkgGestorq.N36SetParam n36Set(Connection conn) {
            PkgGestorq.N36SetParam param = newN36SetParam();
            n36Set(conn, param);
            return param;
        }

        public void n36Set(Connection conn, PkgGestorq.N36SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N36_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.N39GetParam n39Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N39GetParam param = newN39GetParam(map);
            n39Get(conn, param);
            return param;
        }

        public PkgGestorq.N39GetParam n39Get(Connection conn, JSONObject json) {
            PkgGestorq.N39GetParam param = newN39GetParam(json);
            n39Get(conn, param);
            return param;
        }

        public PkgGestorq.N39GetParam n39Get(Connection conn) {
            PkgGestorq.N39GetParam param = newN39GetParam();
            n39Get(conn, param);
            return param;
        }

        public void n39Get(Connection conn, PkgGestorq.N39GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N39_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // numesuce
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numesuce";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 20;
            if (string.IsNullOrEmpty(param.Numesuce))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numesuce;
            // numedr
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numedr";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 20;
            if (string.IsNullOrEmpty(param.Numedr))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numedr;
            cmd.ExecuteNonQuery();
            if(DBNull.Value.Equals(cmd.Parameters["@numesuce"].Value))
                param.Numesuce = null;
            else
                param.Numesuce = (string)cmd.Parameters["@numesuce"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@numedr"].Value))
                param.Numedr = null;
            else
                param.Numedr = (string)cmd.Parameters["@numedr"].Value;
        }

        public PkgGestorq.N39SetParam n39Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N39SetParam param = newN39SetParam(map);
            n39Set(conn, param);
            return param;
        }

        public PkgGestorq.N39SetParam n39Set(Connection conn, JSONObject json) {
            PkgGestorq.N39SetParam param = newN39SetParam(json);
            n39Set(conn, param);
            return param;
        }

        public PkgGestorq.N39SetParam n39Set(Connection conn) {
            PkgGestorq.N39SetParam param = newN39SetParam();
            n39Set(conn, param);
            return param;
        }

        public void n39Set(Connection conn, PkgGestorq.N39SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N39_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.N48GetParam n48Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N48GetParam param = newN48GetParam(map);
            n48Get(conn, param);
            return param;
        }

        public PkgGestorq.N48GetParam n48Get(Connection conn, JSONObject json) {
            PkgGestorq.N48GetParam param = newN48GetParam(json);
            n48Get(conn, param);
            return param;
        }

        public PkgGestorq.N48GetParam n48Get(Connection conn) {
            PkgGestorq.N48GetParam param = newN48GetParam();
            n48Get(conn, param);
            return param;
        }

        public void n48Get(Connection conn, PkgGestorq.N48GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N48_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // numesuce
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numesuce";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 20;
            if (string.IsNullOrEmpty(param.Numesuce))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numesuce;
            cmd.ExecuteNonQuery();
            if(DBNull.Value.Equals(cmd.Parameters["@numesuce"].Value))
                param.Numesuce = null;
            else
                param.Numesuce = (string)cmd.Parameters["@numesuce"].Value;
        }

        public PkgGestorq.N48SetParam n48Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N48SetParam param = newN48SetParam(map);
            n48Set(conn, param);
            return param;
        }

        public PkgGestorq.N48SetParam n48Set(Connection conn, JSONObject json) {
            PkgGestorq.N48SetParam param = newN48SetParam(json);
            n48Set(conn, param);
            return param;
        }

        public PkgGestorq.N48SetParam n48Set(Connection conn) {
            PkgGestorq.N48SetParam param = newN48SetParam();
            n48Set(conn, param);
            return param;
        }

        public void n48Set(Connection conn, PkgGestorq.N48SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N48_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.N49GetParam n49Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N49GetParam param = newN49GetParam(map);
            n49Get(conn, param);
            return param;
        }

        public PkgGestorq.N49GetParam n49Get(Connection conn, JSONObject json) {
            PkgGestorq.N49GetParam param = newN49GetParam(json);
            n49Get(conn, param);
            return param;
        }

        public PkgGestorq.N49GetParam n49Get(Connection conn) {
            PkgGestorq.N49GetParam param = newN49GetParam();
            n49Get(conn, param);
            return param;
        }

        public void n49Get(Connection conn, PkgGestorq.N49GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N49_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // numesuce
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numesuce";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 20;
            if (string.IsNullOrEmpty(param.Numesuce))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numesuce;
            cmd.ExecuteNonQuery();
            if(DBNull.Value.Equals(cmd.Parameters["@numesuce"].Value))
                param.Numesuce = null;
            else
                param.Numesuce = (string)cmd.Parameters["@numesuce"].Value;
        }

        public PkgGestorq.N49SetParam n49Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N49SetParam param = newN49SetParam(map);
            n49Set(conn, param);
            return param;
        }

        public PkgGestorq.N49SetParam n49Set(Connection conn, JSONObject json) {
            PkgGestorq.N49SetParam param = newN49SetParam(json);
            n49Set(conn, param);
            return param;
        }

        public PkgGestorq.N49SetParam n49Set(Connection conn) {
            PkgGestorq.N49SetParam param = newN49SetParam();
            n49Set(conn, param);
            return param;
        }

        public void n49Set(Connection conn, PkgGestorq.N49SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N49_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.N57GetParam n57Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N57GetParam param = newN57GetParam(map);
            n57Get(conn, param);
            return param;
        }

        public PkgGestorq.N57GetParam n57Get(Connection conn, JSONObject json) {
            PkgGestorq.N57GetParam param = newN57GetParam(json);
            n57Get(conn, param);
            return param;
        }

        public PkgGestorq.N57GetParam n57Get(Connection conn) {
            PkgGestorq.N57GetParam param = newN57GetParam();
            n57Get(conn, param);
            return param;
        }

        public void n57Get(Connection conn, PkgGestorq.N57GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N57_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // docnumero
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@docnumero";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 20;
            if (string.IsNullOrEmpty(param.Docnumero))
                par.Value = DBNull.Value;
            else
                par.Value = param.Docnumero;
            // usuario
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@usuario";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 20;
            if (string.IsNullOrEmpty(param.Usuario))
                par.Value = DBNull.Value;
            else
                par.Value = param.Usuario;
            cmd.ExecuteNonQuery();
            if(DBNull.Value.Equals(cmd.Parameters["@docnumero"].Value))
                param.Docnumero = null;
            else
                param.Docnumero = (string)cmd.Parameters["@docnumero"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@usuario"].Value))
                param.Usuario = null;
            else
                param.Usuario = (string)cmd.Parameters["@usuario"].Value;
        }

        public PkgGestorq.N57SetParam n57Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N57SetParam param = newN57SetParam(map);
            n57Set(conn, param);
            return param;
        }

        public PkgGestorq.N57SetParam n57Set(Connection conn, JSONObject json) {
            PkgGestorq.N57SetParam param = newN57SetParam(json);
            n57Set(conn, param);
            return param;
        }

        public PkgGestorq.N57SetParam n57Set(Connection conn) {
            PkgGestorq.N57SetParam param = newN57SetParam();
            n57Set(conn, param);
            return param;
        }

        public void n57Set(Connection conn, PkgGestorq.N57SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N57_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.N66GetParam n66Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N66GetParam param = newN66GetParam(map);
            n66Get(conn, param);
            return param;
        }

        public PkgGestorq.N66GetParam n66Get(Connection conn, JSONObject json) {
            PkgGestorq.N66GetParam param = newN66GetParam(json);
            n66Get(conn, param);
            return param;
        }

        public PkgGestorq.N66GetParam n66Get(Connection conn) {
            PkgGestorq.N66GetParam param = newN66GetParam();
            n66Get(conn, param);
            return param;
        }

        public void n66Get(Connection conn, PkgGestorq.N66GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N66_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // numesuce
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numesuce";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 50;
            if (string.IsNullOrEmpty(param.Numesuce))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numesuce;
            // tasa
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@tasa";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Decimal;
            if (param.Tasa == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Tasa;
            // motivo
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@motivo";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.String;
            par.Size = 1000;
            if (string.IsNullOrEmpty(param.Motivo))
                par.Value = DBNull.Value;
            else
                par.Value = param.Motivo;
            cmd.ExecuteNonQuery();
            if(DBNull.Value.Equals(cmd.Parameters["@numesuce"].Value))
                param.Numesuce = null;
            else
                param.Numesuce = (string)cmd.Parameters["@numesuce"].Value;
        }

        public PkgGestorq.N66SetParam n66Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N66SetParam param = newN66SetParam(map);
            n66Set(conn, param);
            return param;
        }

        public PkgGestorq.N66SetParam n66Set(Connection conn, JSONObject json) {
            PkgGestorq.N66SetParam param = newN66SetParam(json);
            n66Set(conn, param);
            return param;
        }

        public PkgGestorq.N66SetParam n66Set(Connection conn) {
            PkgGestorq.N66SetParam param = newN66SetParam();
            n66Set(conn, param);
            return param;
        }

        public void n66Set(Connection conn, PkgGestorq.N66SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N66_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.N7GetParam n7Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N7GetParam param = newN7GetParam(map);
            n7Get(conn, param);
            return param;
        }

        public PkgGestorq.N7GetParam n7Get(Connection conn, JSONObject json) {
            PkgGestorq.N7GetParam param = newN7GetParam(json);
            n7Get(conn, param);
            return param;
        }

        public PkgGestorq.N7GetParam n7Get(Connection conn) {
            PkgGestorq.N7GetParam param = newN7GetParam();
            n7Get(conn, param);
            return param;
        }

        public void n7Get(Connection conn, PkgGestorq.N7GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N7_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // numexpediente
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numexpediente";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 20;
            if (string.IsNullOrEmpty(param.Numexpediente))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numexpediente;
            // docnumero
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@docnumero";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 20;
            if (string.IsNullOrEmpty(param.Docnumero))
                par.Value = DBNull.Value;
            else
                par.Value = param.Docnumero;
            cmd.ExecuteNonQuery();
            if(DBNull.Value.Equals(cmd.Parameters["@numexpediente"].Value))
                param.Numexpediente = null;
            else
                param.Numexpediente = (string)cmd.Parameters["@numexpediente"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@docnumero"].Value))
                param.Docnumero = null;
            else
                param.Docnumero = (string)cmd.Parameters["@docnumero"].Value;
        }

        public PkgGestorq.N7SetParam n7Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N7SetParam param = newN7SetParam(map);
            n7Set(conn, param);
            return param;
        }

        public PkgGestorq.N7SetParam n7Set(Connection conn, JSONObject json) {
            PkgGestorq.N7SetParam param = newN7SetParam(json);
            n7Set(conn, param);
            return param;
        }

        public PkgGestorq.N7SetParam n7Set(Connection conn) {
            PkgGestorq.N7SetParam param = newN7SetParam();
            n7Set(conn, param);
            return param;
        }

        public void n7Set(Connection conn, PkgGestorq.N7SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N7_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.N8GetParam n8Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N8GetParam param = newN8GetParam(map);
            n8Get(conn, param);
            return param;
        }

        public PkgGestorq.N8GetParam n8Get(Connection conn, JSONObject json) {
            PkgGestorq.N8GetParam param = newN8GetParam(json);
            n8Get(conn, param);
            return param;
        }

        public PkgGestorq.N8GetParam n8Get(Connection conn) {
            PkgGestorq.N8GetParam param = newN8GetParam();
            n8Get(conn, param);
            return param;
        }

        public void n8Get(Connection conn, PkgGestorq.N8GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N8_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // iddr
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@iddr";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.Int32;
            if (param.Iddr == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Iddr;
            // numsuce
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numsuce";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 50;
            if (string.IsNullOrEmpty(param.Numsuce))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numsuce;
            // numdr
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numdr";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 50;
            if (string.IsNullOrEmpty(param.Numdr))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numdr;
            // numeorden
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numeorden";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 50;
            if (string.IsNullOrEmpty(param.Numeorden))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numeorden;
            cmd.ExecuteNonQuery();
            if(DBNull.Value.Equals(cmd.Parameters["@iddr"].Value))
                param.Iddr = null;
            else
                param.Iddr = (int?)cmd.Parameters["@iddr"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@numsuce"].Value))
                param.Numsuce = null;
            else
                param.Numsuce = (string)cmd.Parameters["@numsuce"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@numdr"].Value))
                param.Numdr = null;
            else
                param.Numdr = (string)cmd.Parameters["@numdr"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@numeorden"].Value))
                param.Numeorden = null;
            else
                param.Numeorden = (string)cmd.Parameters["@numeorden"].Value;
        }

        public PkgGestorq.N8SetParam n8Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N8SetParam param = newN8SetParam(map);
            n8Set(conn, param);
            return param;
        }

        public PkgGestorq.N8SetParam n8Set(Connection conn, JSONObject json) {
            PkgGestorq.N8SetParam param = newN8SetParam(json);
            n8Set(conn, param);
            return param;
        }

        public PkgGestorq.N8SetParam n8Set(Connection conn) {
            PkgGestorq.N8SetParam param = newN8SetParam();
            n8Set(conn, param);
            return param;
        }

        public void n8Set(Connection conn, PkgGestorq.N8SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N8_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.N9GetParam n9Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N9GetParam param = newN9GetParam(map);
            n9Get(conn, param);
            return param;
        }

        public PkgGestorq.N9GetParam n9Get(Connection conn, JSONObject json) {
            PkgGestorq.N9GetParam param = newN9GetParam(json);
            n9Get(conn, param);
            return param;
        }

        public PkgGestorq.N9GetParam n9Get(Connection conn) {
            PkgGestorq.N9GetParam param = newN9GetParam();
            n9Get(conn, param);
            return param;
        }

        public void n9Get(Connection conn, PkgGestorq.N9GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N9_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // iddr
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@iddr";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.Int32;
            if (param.Iddr == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Iddr;
            // numsuce
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numsuce";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 50;
            if (string.IsNullOrEmpty(param.Numsuce))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numsuce;
            // numdr
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numdr";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 50;
            if (string.IsNullOrEmpty(param.Numdr))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numdr;
            // numeorden
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@numeorden";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 50;
            if (string.IsNullOrEmpty(param.Numeorden))
                par.Value = DBNull.Value;
            else
                par.Value = param.Numeorden;
            // texto
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@texto";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.String;
            par.Size = 4000;
            if (string.IsNullOrEmpty(param.Texto))
                par.Value = DBNull.Value;
            else
                par.Value = param.Texto;
            cmd.ExecuteNonQuery();
            if(DBNull.Value.Equals(cmd.Parameters["@iddr"].Value))
                param.Iddr = null;
            else
                param.Iddr = (int?)cmd.Parameters["@iddr"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@numsuce"].Value))
                param.Numsuce = null;
            else
                param.Numsuce = (string)cmd.Parameters["@numsuce"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@numdr"].Value))
                param.Numdr = null;
            else
                param.Numdr = (string)cmd.Parameters["@numdr"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@numeorden"].Value))
                param.Numeorden = null;
            else
                param.Numeorden = (string)cmd.Parameters["@numeorden"].Value;
            if(DBNull.Value.Equals(cmd.Parameters["@texto"].Value))
                param.Texto = null;
            else
                param.Texto = (string)cmd.Parameters["@texto"].Value;
        }

        public PkgGestorq.N9SetParam n9Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.N9SetParam param = newN9SetParam(map);
            n9Set(conn, param);
            return param;
        }

        public PkgGestorq.N9SetParam n9Set(Connection conn, JSONObject json) {
            PkgGestorq.N9SetParam param = newN9SetParam(json);
            n9Set(conn, param);
            return param;
        }

        public PkgGestorq.N9SetParam n9Set(Connection conn) {
            PkgGestorq.N9SetParam param = newN9SetParam();
            n9Set(conn, param);
            return param;
        }

        public void n9Set(Connection conn, PkgGestorq.N9SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_N9_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.PushParam push(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.PushParam param = newPushParam(map);
            push(conn, param);
            return param;
        }

        public PkgGestorq.PushParam push(Connection conn, JSONObject json) {
            PkgGestorq.PushParam param = newPushParam(json);
            push(conn, param);
            return param;
        }

        public PkgGestorq.PushParam push(Connection conn) {
            PkgGestorq.PushParam param = newPushParam();
            push(conn, param);
            return param;
        }

        public void push(Connection conn, PkgGestorq.PushParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_push";
            DbParameter par = null;
            // tipomensaje
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@tipomensaje";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.String;
            par.Size = 20;
            if (string.IsNullOrEmpty(param.Tipomensaje))
                par.Value = DBNull.Value;
            else
                par.Value = param.Tipomensaje;
            // idsolicitud
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idsolicitud";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idsolicitud == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idsolicitud;
            // idversion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idversion";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idversion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idversion;
            // tasa
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@tasa";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Decimal;
            if (param.Tasa == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Tasa;
            // iditem
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@iditem";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Iditem == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Iditem;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.PushTrazaParam pushTraza(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.PushTrazaParam param = newPushTrazaParam(map);
            pushTraza(conn, param);
            return param;
        }

        public PkgGestorq.PushTrazaParam pushTraza(Connection conn, JSONObject json) {
            PkgGestorq.PushTrazaParam param = newPushTrazaParam(json);
            pushTraza(conn, param);
            return param;
        }

        public PkgGestorq.PushTrazaParam pushTraza(Connection conn) {
            PkgGestorq.PushTrazaParam param = newPushTrazaParam();
            pushTraza(conn, param);
            return param;
        }

        public void pushTraza(Connection conn, PkgGestorq.PushTrazaParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_push_traza";
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.Serv1GetParam serv1Get(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.Serv1GetParam param = newServ1GetParam(map);
            serv1Get(conn, param);
            return param;
        }

        public PkgGestorq.Serv1GetParam serv1Get(Connection conn, JSONObject json) {
            PkgGestorq.Serv1GetParam param = newServ1GetParam(json);
            serv1Get(conn, param);
            return param;
        }

        public PkgGestorq.Serv1GetParam serv1Get(Connection conn) {
            PkgGestorq.Serv1GetParam param = newServ1GetParam();
            serv1Get(conn, param);
            return param;
        }

        public void serv1Get(Connection conn, PkgGestorq.Serv1GetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_SERV1_get";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // idnotificacion
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idnotificacion";
            par.Direction = ParameterDirection.InputOutput;
            par.DbType = DbType.Int32;
            if (param.Idnotificacion == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idnotificacion;
            cmd.ExecuteNonQuery();
            if(DBNull.Value.Equals(cmd.Parameters["@idnotificacion"].Value))
                param.Idnotificacion = null;
            else
                param.Idnotificacion = (int?)cmd.Parameters["@idnotificacion"].Value;
        }

        public PkgGestorq.Serv1SetParam serv1Set(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.Serv1SetParam param = newServ1SetParam(map);
            serv1Set(conn, param);
            return param;
        }

        public PkgGestorq.Serv1SetParam serv1Set(Connection conn, JSONObject json) {
            PkgGestorq.Serv1SetParam param = newServ1SetParam(json);
            serv1Set(conn, param);
            return param;
        }

        public PkgGestorq.Serv1SetParam serv1Set(Connection conn) {
            PkgGestorq.Serv1SetParam param = newServ1SetParam();
            serv1Set(conn, param);
            return param;
        }

        public void serv1Set(Connection conn, PkgGestorq.Serv1SetParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_SERV1_set";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.SetEstadoParam setEstado(Connection conn, Dictionary<string, string> map) {
            PkgGestorq.SetEstadoParam param = newSetEstadoParam(map);
            setEstado(conn, param);
            return param;
        }

        public PkgGestorq.SetEstadoParam setEstado(Connection conn, JSONObject json) {
            PkgGestorq.SetEstadoParam param = newSetEstadoParam(json);
            setEstado(conn, param);
            return param;
        }

        public PkgGestorq.SetEstadoParam setEstado(Connection conn) {
            PkgGestorq.SetEstadoParam param = newSetEstadoParam();
            setEstado(conn, param);
            return param;
        }

        public void setEstado(Connection conn, PkgGestorq.SetEstadoParam param) {
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "[dbo].GEQ_set_estado";
            DbParameter par = null;
            // idq
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@idq";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.Int32;
            if (param.Idq == null)
                par.Value = DBNull.Value;
            else
                par.Value = param.Idq;
            // error
            par = cmd.CreateParameter();
            cmd.Parameters.Add(par);
            par.ParameterName = "@error";
            par.Direction = ParameterDirection.Input;
            par.DbType = DbType.String;
            par.Size = -1;
            if (string.IsNullOrEmpty(param.Error))
                par.Value = DBNull.Value;
            else
                par.Value = param.Error;
            cmd.ExecuteNonQuery();
        }

        public PkgGestorq.GetPendienteParam newGetPendienteParam() {
            return new GetPendienteParam();
        }

        public PkgGestorq.GetPendienteParam newGetPendienteParam(Dictionary<string, string> map) {
            return new GetPendienteParam(map);
        }

        public PkgGestorq.GetPendienteParam newGetPendienteParam(JSONObject json) {
            return new GetPendienteParam(json);
        }

        public PkgGestorq.N11GetParam newN11GetParam() {
            return new N11GetParam();
        }

        public PkgGestorq.N11GetParam newN11GetParam(Dictionary<string, string> map) {
            return new N11GetParam(map);
        }

        public PkgGestorq.N11GetParam newN11GetParam(JSONObject json) {
            return new N11GetParam(json);
        }

        public PkgGestorq.N11SetParam newN11SetParam() {
            return new N11SetParam();
        }

        public PkgGestorq.N11SetParam newN11SetParam(Dictionary<string, string> map) {
            return new N11SetParam(map);
        }

        public PkgGestorq.N11SetParam newN11SetParam(JSONObject json) {
            return new N11SetParam(json);
        }

        public PkgGestorq.N15GetParam newN15GetParam() {
            return new N15GetParam();
        }

        public PkgGestorq.N15GetParam newN15GetParam(Dictionary<string, string> map) {
            return new N15GetParam(map);
        }

        public PkgGestorq.N15GetParam newN15GetParam(JSONObject json) {
            return new N15GetParam(json);
        }

        public PkgGestorq.N15SetParam newN15SetParam() {
            return new N15SetParam();
        }

        public PkgGestorq.N15SetParam newN15SetParam(Dictionary<string, string> map) {
            return new N15SetParam(map);
        }

        public PkgGestorq.N15SetParam newN15SetParam(JSONObject json) {
            return new N15SetParam(json);
        }

        public PkgGestorq.N17GetParam newN17GetParam() {
            return new N17GetParam();
        }

        public PkgGestorq.N17GetParam newN17GetParam(Dictionary<string, string> map) {
            return new N17GetParam(map);
        }

        public PkgGestorq.N17GetParam newN17GetParam(JSONObject json) {
            return new N17GetParam(json);
        }

        public PkgGestorq.N17SetParam newN17SetParam() {
            return new N17SetParam();
        }

        public PkgGestorq.N17SetParam newN17SetParam(Dictionary<string, string> map) {
            return new N17SetParam(map);
        }

        public PkgGestorq.N17SetParam newN17SetParam(JSONObject json) {
            return new N17SetParam(json);
        }

        public PkgGestorq.N19GetParam newN19GetParam() {
            return new N19GetParam();
        }

        public PkgGestorq.N19GetParam newN19GetParam(Dictionary<string, string> map) {
            return new N19GetParam(map);
        }

        public PkgGestorq.N19GetParam newN19GetParam(JSONObject json) {
            return new N19GetParam(json);
        }

        public PkgGestorq.N19SetParam newN19SetParam() {
            return new N19SetParam();
        }

        public PkgGestorq.N19SetParam newN19SetParam(Dictionary<string, string> map) {
            return new N19SetParam(map);
        }

        public PkgGestorq.N19SetParam newN19SetParam(JSONObject json) {
            return new N19SetParam(json);
        }

        public PkgGestorq.N2GetParam newN2GetParam() {
            return new N2GetParam();
        }

        public PkgGestorq.N2GetParam newN2GetParam(Dictionary<string, string> map) {
            return new N2GetParam(map);
        }

        public PkgGestorq.N2GetParam newN2GetParam(JSONObject json) {
            return new N2GetParam(json);
        }

        public PkgGestorq.N2SetParam newN2SetParam() {
            return new N2SetParam();
        }

        public PkgGestorq.N2SetParam newN2SetParam(Dictionary<string, string> map) {
            return new N2SetParam(map);
        }

        public PkgGestorq.N2SetParam newN2SetParam(JSONObject json) {
            return new N2SetParam(json);
        }

        public PkgGestorq.N21GetParam newN21GetParam() {
            return new N21GetParam();
        }

        public PkgGestorq.N21GetParam newN21GetParam(Dictionary<string, string> map) {
            return new N21GetParam(map);
        }

        public PkgGestorq.N21GetParam newN21GetParam(JSONObject json) {
            return new N21GetParam(json);
        }

        public PkgGestorq.N21SetParam newN21SetParam() {
            return new N21SetParam();
        }

        public PkgGestorq.N21SetParam newN21SetParam(Dictionary<string, string> map) {
            return new N21SetParam(map);
        }

        public PkgGestorq.N21SetParam newN21SetParam(JSONObject json) {
            return new N21SetParam(json);
        }

        public PkgGestorq.N22GetParam newN22GetParam() {
            return new N22GetParam();
        }

        public PkgGestorq.N22GetParam newN22GetParam(Dictionary<string, string> map) {
            return new N22GetParam(map);
        }

        public PkgGestorq.N22GetParam newN22GetParam(JSONObject json) {
            return new N22GetParam(json);
        }

        public PkgGestorq.N22SetParam newN22SetParam() {
            return new N22SetParam();
        }

        public PkgGestorq.N22SetParam newN22SetParam(Dictionary<string, string> map) {
            return new N22SetParam(map);
        }

        public PkgGestorq.N22SetParam newN22SetParam(JSONObject json) {
            return new N22SetParam(json);
        }

        public PkgGestorq.N36GetParam newN36GetParam() {
            return new N36GetParam();
        }

        public PkgGestorq.N36GetParam newN36GetParam(Dictionary<string, string> map) {
            return new N36GetParam(map);
        }

        public PkgGestorq.N36GetParam newN36GetParam(JSONObject json) {
            return new N36GetParam(json);
        }

        public PkgGestorq.N36SetParam newN36SetParam() {
            return new N36SetParam();
        }

        public PkgGestorq.N36SetParam newN36SetParam(Dictionary<string, string> map) {
            return new N36SetParam(map);
        }

        public PkgGestorq.N36SetParam newN36SetParam(JSONObject json) {
            return new N36SetParam(json);
        }

        public PkgGestorq.N39GetParam newN39GetParam() {
            return new N39GetParam();
        }

        public PkgGestorq.N39GetParam newN39GetParam(Dictionary<string, string> map) {
            return new N39GetParam(map);
        }

        public PkgGestorq.N39GetParam newN39GetParam(JSONObject json) {
            return new N39GetParam(json);
        }

        public PkgGestorq.N39SetParam newN39SetParam() {
            return new N39SetParam();
        }

        public PkgGestorq.N39SetParam newN39SetParam(Dictionary<string, string> map) {
            return new N39SetParam(map);
        }

        public PkgGestorq.N39SetParam newN39SetParam(JSONObject json) {
            return new N39SetParam(json);
        }

        public PkgGestorq.N48GetParam newN48GetParam() {
            return new N48GetParam();
        }

        public PkgGestorq.N48GetParam newN48GetParam(Dictionary<string, string> map) {
            return new N48GetParam(map);
        }

        public PkgGestorq.N48GetParam newN48GetParam(JSONObject json) {
            return new N48GetParam(json);
        }

        public PkgGestorq.N48SetParam newN48SetParam() {
            return new N48SetParam();
        }

        public PkgGestorq.N48SetParam newN48SetParam(Dictionary<string, string> map) {
            return new N48SetParam(map);
        }

        public PkgGestorq.N48SetParam newN48SetParam(JSONObject json) {
            return new N48SetParam(json);
        }

        public PkgGestorq.N49GetParam newN49GetParam() {
            return new N49GetParam();
        }

        public PkgGestorq.N49GetParam newN49GetParam(Dictionary<string, string> map) {
            return new N49GetParam(map);
        }

        public PkgGestorq.N49GetParam newN49GetParam(JSONObject json) {
            return new N49GetParam(json);
        }

        public PkgGestorq.N49SetParam newN49SetParam() {
            return new N49SetParam();
        }

        public PkgGestorq.N49SetParam newN49SetParam(Dictionary<string, string> map) {
            return new N49SetParam(map);
        }

        public PkgGestorq.N49SetParam newN49SetParam(JSONObject json) {
            return new N49SetParam(json);
        }

        public PkgGestorq.N57GetParam newN57GetParam() {
            return new N57GetParam();
        }

        public PkgGestorq.N57GetParam newN57GetParam(Dictionary<string, string> map) {
            return new N57GetParam(map);
        }

        public PkgGestorq.N57GetParam newN57GetParam(JSONObject json) {
            return new N57GetParam(json);
        }

        public PkgGestorq.N57SetParam newN57SetParam() {
            return new N57SetParam();
        }

        public PkgGestorq.N57SetParam newN57SetParam(Dictionary<string, string> map) {
            return new N57SetParam(map);
        }

        public PkgGestorq.N57SetParam newN57SetParam(JSONObject json) {
            return new N57SetParam(json);
        }

        public PkgGestorq.N66GetParam newN66GetParam() {
            return new N66GetParam();
        }

        public PkgGestorq.N66GetParam newN66GetParam(Dictionary<string, string> map) {
            return new N66GetParam(map);
        }

        public PkgGestorq.N66GetParam newN66GetParam(JSONObject json) {
            return new N66GetParam(json);
        }

        public PkgGestorq.N66SetParam newN66SetParam() {
            return new N66SetParam();
        }

        public PkgGestorq.N66SetParam newN66SetParam(Dictionary<string, string> map) {
            return new N66SetParam(map);
        }

        public PkgGestorq.N66SetParam newN66SetParam(JSONObject json) {
            return new N66SetParam(json);
        }

        public PkgGestorq.N7GetParam newN7GetParam() {
            return new N7GetParam();
        }

        public PkgGestorq.N7GetParam newN7GetParam(Dictionary<string, string> map) {
            return new N7GetParam(map);
        }

        public PkgGestorq.N7GetParam newN7GetParam(JSONObject json) {
            return new N7GetParam(json);
        }

        public PkgGestorq.N7SetParam newN7SetParam() {
            return new N7SetParam();
        }

        public PkgGestorq.N7SetParam newN7SetParam(Dictionary<string, string> map) {
            return new N7SetParam(map);
        }

        public PkgGestorq.N7SetParam newN7SetParam(JSONObject json) {
            return new N7SetParam(json);
        }

        public PkgGestorq.N8GetParam newN8GetParam() {
            return new N8GetParam();
        }

        public PkgGestorq.N8GetParam newN8GetParam(Dictionary<string, string> map) {
            return new N8GetParam(map);
        }

        public PkgGestorq.N8GetParam newN8GetParam(JSONObject json) {
            return new N8GetParam(json);
        }

        public PkgGestorq.N8SetParam newN8SetParam() {
            return new N8SetParam();
        }

        public PkgGestorq.N8SetParam newN8SetParam(Dictionary<string, string> map) {
            return new N8SetParam(map);
        }

        public PkgGestorq.N8SetParam newN8SetParam(JSONObject json) {
            return new N8SetParam(json);
        }

        public PkgGestorq.N9GetParam newN9GetParam() {
            return new N9GetParam();
        }

        public PkgGestorq.N9GetParam newN9GetParam(Dictionary<string, string> map) {
            return new N9GetParam(map);
        }

        public PkgGestorq.N9GetParam newN9GetParam(JSONObject json) {
            return new N9GetParam(json);
        }

        public PkgGestorq.N9SetParam newN9SetParam() {
            return new N9SetParam();
        }

        public PkgGestorq.N9SetParam newN9SetParam(Dictionary<string, string> map) {
            return new N9SetParam(map);
        }

        public PkgGestorq.N9SetParam newN9SetParam(JSONObject json) {
            return new N9SetParam(json);
        }

        public PkgGestorq.PushParam newPushParam() {
            return new PushParam();
        }

        public PkgGestorq.PushParam newPushParam(Dictionary<string, string> map) {
            return new PushParam(map);
        }

        public PkgGestorq.PushParam newPushParam(JSONObject json) {
            return new PushParam(json);
        }

        public PkgGestorq.PushTrazaParam newPushTrazaParam() {
            return new PushTrazaParam();
        }

        public PkgGestorq.PushTrazaParam newPushTrazaParam(Dictionary<string, string> map) {
            return new PushTrazaParam(map);
        }

        public PkgGestorq.PushTrazaParam newPushTrazaParam(JSONObject json) {
            return new PushTrazaParam(json);
        }

        public PkgGestorq.Serv1GetParam newServ1GetParam() {
            return new Serv1GetParam();
        }

        public PkgGestorq.Serv1GetParam newServ1GetParam(Dictionary<string, string> map) {
            return new Serv1GetParam(map);
        }

        public PkgGestorq.Serv1GetParam newServ1GetParam(JSONObject json) {
            return new Serv1GetParam(json);
        }

        public PkgGestorq.Serv1SetParam newServ1SetParam() {
            return new Serv1SetParam();
        }

        public PkgGestorq.Serv1SetParam newServ1SetParam(Dictionary<string, string> map) {
            return new Serv1SetParam(map);
        }

        public PkgGestorq.Serv1SetParam newServ1SetParam(JSONObject json) {
            return new Serv1SetParam(json);
        }

        public PkgGestorq.SetEstadoParam newSetEstadoParam() {
            return new SetEstadoParam();
        }

        public PkgGestorq.SetEstadoParam newSetEstadoParam(Dictionary<string, string> map) {
            return new SetEstadoParam(map);
        }

        public PkgGestorq.SetEstadoParam newSetEstadoParam(JSONObject json) {
            return new SetEstadoParam(json);
        }

        public class GetPendienteParam {

            private int? idqultimo;
            private DbDataReader curOut;

            public GetPendienteParam() {
            }

            public GetPendienteParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public GetPendienteParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idqultimo {
                get { return idqultimo; }
                set { this.idqultimo = value; }
            }

            public DbDataReader CurOut {
                get { return curOut; }
                set { this.curOut = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N11GetParam {

            private int? idq;
            private string numeorden;
            private int? idsubsanacion;
            private string numesuce;
            private string texto;

            public N11GetParam() {
            }

            public N11GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N11GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public string Numeorden {
                get { return numeorden; }
                set { this.numeorden = value; }
            }

            public int? Idsubsanacion {
                get { return idsubsanacion; }
                set { this.idsubsanacion = value; }
            }

            public string Numesuce {
                get { return numesuce; }
                set { this.numesuce = value; }
            }

            public string Texto {
                get { return texto; }
                set { this.texto = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N11SetParam {

            private int? idq;
            private int? idnotificacion;

            public N11SetParam() {
            }

            public N11SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N11SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N15GetParam {

            private int? idq;
            private string numeorden;
            private string numemto;
            private string texto;

            public N15GetParam() {
            }

            public N15GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N15GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public string Numeorden {
                get { return numeorden; }
                set { this.numeorden = value; }
            }

            public string Numemto {
                get { return numemto; }
                set { this.numemto = value; }
            }

            public string Texto {
                get { return texto; }
                set { this.texto = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N15SetParam {

            private int? idq;
            private int? idnotificacion;

            public N15SetParam() {
            }

            public N15SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N15SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N17GetParam {

            private int? idq;
            private string numeorden;
            private int? idsubsanacion;
            private string numesuce;
            private decimal? tasa;
            private int? plazo;
            private string texto;

            public N17GetParam() {
            }

            public N17GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N17GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public string Numeorden {
                get { return numeorden; }
                set { this.numeorden = value; }
            }

            public int? Idsubsanacion {
                get { return idsubsanacion; }
                set { this.idsubsanacion = value; }
            }

            public string Numesuce {
                get { return numesuce; }
                set { this.numesuce = value; }
            }

            public decimal? Tasa {
                get { return tasa; }
                set { this.tasa = value; }
            }

            public int? Plazo {
                get { return plazo; }
                set { this.plazo = value; }
            }

            public string Texto {
                get { return texto; }
                set { this.texto = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N17SetParam {

            private int? idq;
            private int? idnotificacion;

            public N17SetParam() {
            }

            public N17SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N17SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N19GetParam {

            private int? idq;
            private string numemos;
            private string numesuce;
            private string texto;
            private string numeorden;
            private int? version;

            public N19GetParam() {
            }

            public N19GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N19GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public string Numemos {
                get { return numemos; }
                set { this.numemos = value; }
            }

            public string Numesuce {
                get { return numesuce; }
                set { this.numesuce = value; }
            }

            public string Texto {
                get { return texto; }
                set { this.texto = value; }
            }


            public string Numeorden
            {
                get { return numeorden; }
                set { numeorden = value; }
            }
            public int? Version
            {
                get { return version; }
                set { version = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N19SetParam {

            private int? idq;
            private int? idnotificacion;

            public N19SetParam() {
            }

            public N19SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N19SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N2GetParam {

            private int? idq;
            private string docnumero;
            private string codformato;
            private decimal? tasa;

            public N2GetParam() {
            }

            public N2GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N2GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public string Docnumero {
                get { return docnumero; }
                set { this.docnumero = value; }
            }

            public string Codformato {
                get { return codformato; }
                set { this.codformato = value; }
            }

            public decimal? Tasa {
                get { return tasa; }
                set { this.tasa = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N2SetParam {

            private int? idq;
            private int? idnotificacion;

            public N2SetParam() {
            }

            public N2SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N2SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N21GetParam {

            private int? idq;
            private string numemos;
            private string numesuce;

            public N21GetParam() {
            }

            public N21GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N21GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public string Numemos {
                get { return numemos; }
                set { this.numemos = value; }
            }

            public string Numesuce {
                get { return numesuce; }
                set { this.numesuce = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N21SetParam {

            private int? idq;
            private int? idnotificacion;

            public N21SetParam() {
            }

            public N21SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N21SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N22GetParam {

            private int? idq;
            private string nummos;
            private string numsuce;
            private decimal? tasa;

            public N22GetParam() {
            }

            public N22GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N22GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public string Nummos {
                get { return nummos; }
                set { this.nummos = value; }
            }

            public string Numsuce {
                get { return numsuce; }
                set { this.numsuce = value; }
            }

            public decimal? Tasa {
                get { return tasa; }
                set { this.tasa = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N22SetParam {

            private int? idq;
            private int? idnotificacion;

            public N22SetParam() {
            }

            public N22SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N22SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N36GetParam {

            private int? idq;
            private DbDataReader curOut;

            public N36GetParam() {
            }

            public N36GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N36GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public DbDataReader CurOut {
                get { return curOut; }
                set { this.curOut = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N36SetParam {

            private int? idq;
            private int? idnotificacion;

            public N36SetParam() {
            }

            public N36SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N36SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N39GetParam {

            private int? idq;
            private string numesuce;
            private string numedr;

            public N39GetParam() {
            }

            public N39GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N39GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public string Numesuce {
                get { return numesuce; }
                set { this.numesuce = value; }
            }

            public string Numedr {
                get { return numedr; }
                set { this.numedr = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N39SetParam {

            private int? idq;
            private int? idnotificacion;

            public N39SetParam() {
            }

            public N39SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N39SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N48GetParam {

            private int? idq;
            private string numesuce;

            public N48GetParam() {
            }

            public N48GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N48GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public string Numesuce {
                get { return numesuce; }
                set { this.numesuce = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N48SetParam {

            private int? idq;
            private int? idnotificacion;

            public N48SetParam() {
            }

            public N48SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N48SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N49GetParam {

            private int? idq;
            private string numesuce;

            public N49GetParam() {
            }

            public N49GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N49GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public string Numesuce {
                get { return numesuce; }
                set { this.numesuce = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N49SetParam {

            private int? idq;
            private int? idnotificacion;

            public N49SetParam() {
            }

            public N49SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N49SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N57GetParam {

            private int? idq;
            private string docnumero;
            private string usuario;

            public N57GetParam() {
            }

            public N57GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N57GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public string Docnumero {
                get { return docnumero; }
                set { this.docnumero = value; }
            }

            public string Usuario {
                get { return usuario; }
                set { this.usuario = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N57SetParam {

            private int? idq;
            private int? idnotificacion;

            public N57SetParam() {
            }

            public N57SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N57SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N66GetParam {

            private int? idq;
            private string numesuce;
            private decimal? tasa;
            private string motivo;

            public N66GetParam() {
            }

            public N66GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N66GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public string Numesuce {
                get { return numesuce; }
                set { this.numesuce = value; }
            }

            public decimal? Tasa {
                get { return tasa; }
                set { this.tasa = value; }
            }

            public string Motivo {
                get { return motivo; }
                set { this.motivo = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N66SetParam {

            private int? idq;
            private int? idnotificacion;

            public N66SetParam() {
            }

            public N66SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N66SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N7GetParam {

            private int? idq;
            private string numexpediente;
            private string docnumero;

            public N7GetParam() {
            }

            public N7GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N7GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public string Numexpediente {
                get { return numexpediente; }
                set { this.numexpediente = value; }
            }

            public string Docnumero {
                get { return docnumero; }
                set { this.docnumero = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N7SetParam {

            private int? idq;
            private int? idnotificacion;

            public N7SetParam() {
            }

            public N7SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N7SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N8GetParam {

            private int? idq;
            private int? iddr;
            private string numsuce;
            private string numdr;
            private string numeorden;

            public N8GetParam() {
            }

            public N8GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N8GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Iddr {
                get { return iddr; }
                set { this.iddr = value; }
            }

            public string Numsuce {
                get { return numsuce; }
                set { this.numsuce = value; }
            }

            public string Numdr {
                get { return numdr; }
                set { this.numdr = value; }
            }

            public string Numeorden {
                get { return numeorden; }
                set { this.numeorden = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N8SetParam {

            private int? idq;
            private int? idnotificacion;

            public N8SetParam() {
            }

            public N8SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N8SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N9GetParam {

            private int? idq;
            private int? iddr;
            private string numsuce;
            private string numdr;
            private string numeorden;
            private string texto;

            public N9GetParam() {
            }

            public N9GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N9GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Iddr {
                get { return iddr; }
                set { this.iddr = value; }
            }

            public string Numsuce {
                get { return numsuce; }
                set { this.numsuce = value; }
            }

            public string Numdr {
                get { return numdr; }
                set { this.numdr = value; }
            }

            public string Numeorden {
                get { return numeorden; }
                set { this.numeorden = value; }
            }

            public string Texto {
                get { return texto; }
                set { this.texto = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class N9SetParam {

            private int? idq;
            private int? idnotificacion;

            public N9SetParam() {
            }

            public N9SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public N9SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class PushParam {

            private string tipomensaje;
            private int? idsolicitud;
            private int? idversion;
            private decimal? tasa;
            private int? iditem;

            public PushParam() {
            }

            public PushParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public PushParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public string Tipomensaje {
                get { return tipomensaje; }
                set { this.tipomensaje = value; }
            }

            public int? Idsolicitud {
                get { return idsolicitud; }
                set { this.idsolicitud = value; }
            }

            public int? Idversion {
                get { return idversion; }
                set { this.idversion = value; }
            }

            public decimal? Tasa {
                get { return tasa; }
                set { this.tasa = value; }
            }

            public int? Iditem {
                get { return iditem; }
                set { this.iditem = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class PushTrazaParam {

            public PushTrazaParam() {
            }

            public PushTrazaParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public PushTrazaParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class Serv1GetParam {

            private int? idq;
            private int? idnotificacion;

            public Serv1GetParam() {
            }

            public Serv1GetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public Serv1GetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public int? Idnotificacion {
                get { return idnotificacion; }
                set { this.idnotificacion = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class Serv1SetParam {

            private int? idq;

            public Serv1SetParam() {
            }

            public Serv1SetParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public Serv1SetParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

        public class SetEstadoParam {

            private int? idq;
            private string error;

            public SetEstadoParam() {
            }

            public SetEstadoParam(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public SetEstadoParam(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

            public int? Idq {
                get { return idq; }
                set { this.idq = value; }
            }

            public string Error {
                get { return error; }
                set { this.error = value; }
            }

            public void setValuesFromMap(Dictionary<string, string> map) {
                ResourceManager.populateDtoFromMap(this, map);
            }

            public void setValuesFromMap(JSONObject json) {
                ResourceManager.populateDtoFromMap(this, json);
            }

        }

    }
}
